C:/Projekte/RAIS/Specific Masks/App_Code/IcSRS_Import.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
using System.Xml;
using System.Collections;
using System.Diagnostics;
using System.Data;

namespace IcSRS_Import
{
    public class IcSRS_Import
    {
        private HttpWebRequest webRequest;
        private HttpWebResponse webResponse;
        private string type;
        private string search;
                private string loginIcSRS;
                private string passwordIcSRS;

        public DataTable getSearchResult(string search, string type, string login, string password)
        {
            /* This public method returns a DataTable containing the 
             * respective search result.
             */

            this.search = search;
            this.type = type;
                        this.loginIcSRS = login;
                        this.passwordIcSRS = password;
            switch (type)
            {
                case "Associated Equipment":
                    return this.getDevices();
                case "Source":
                    return this.getSources();
                case "Manufacturer":
                    return this.getManufacturer();
                default:
                    return new DataTable();
            }
        }

        #region CURRENTLY NOT IN USE

        public DataTable getDeviceDetails(string did)
        {
            DataTable details = new DataTable();
            details.Columns.Add("Attribute");
            details.Columns.Add("Value");

            try
            {
                XmlDocument doc = new XmlDocument();
                //doc.Load(getXmlStream("https://icsrs.iaea.org/rais_search.aspx?username=rais_user&pwd=X9zb2[8&schem=0&op=dd&did=" + did));
                                doc.Load(getXmlStream(
                                        string.Format("https://icsrs.iaea.org/rais_search.aspx?username={0}&pwd={1}&schem=0&op=dd&did="
                                                , loginIcSRS
                                                , passwordIcSRS)
                                        + did));
                                DataRow row = details.NewRow();
                foreach (XmlNode node in doc.DocumentElement.ChildNodes[0].ChildNodes)
                {
                    row[0] = node.Name;
                    row[1] = node.InnerText;
                }
                details.Rows.Add(row);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
            }
            return details;
        }

        public DataTable getSourceDetails(string sid)
        {
            DataTable details = new DataTable();
            details.Columns.Add("Attribute");
            details.Columns.Add("Value");

            try
            {
                XmlDocument doc = new XmlDocument();
                //doc.Load(getXmlStream("https://icsrs.iaea.org/rais_search.aspx?username=rais_user&pwd=X9zb2[8&schem=0&op=sd&sid=" + sid));
                                doc.Load(getXmlStream(
                                        string.Format("https://icsrs.iaea.org/rais_search.aspx?username={0}&pwd={1}&schem=0&op=sd&sid="
                                                , loginIcSRS
                                                , passwordIcSRS)
                                        + sid));
                                DataRow row = details.NewRow();
                foreach (XmlNode node in doc.DocumentElement.ChildNodes[0].ChildNodes)
                {
                    row[0] = node.Name;
                    row[1] = node.InnerText;
                }
                details.Rows.Add(row);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
            }
            return details;
        }

        #endregion

        #region PRIVATE HELPER METHODS

        private DataTable getDevices()
        {
            // Create DataTable which has to be returned.
            DataTable devices = new DataTable();
            try
            {
                // Load XML-Document from icsrs.iaea.org, using the getXmlStream Method.
                XmlDocument doc = new XmlDocument();
                //doc.Load(this.getXmlStream("https://icsrs.iaea.org/rais_search.aspx?username=rais_user&pwd=X9zb2[8&qry=" + search + "&schem=0&op=ds&nstart=0&ncount=1000"));
                                doc.Load(this.getXmlStream(
                                        string.Format("https://icsrs.iaea.org/rais_search.aspx?username={0}&pwd={1}&qry="
                                                , loginIcSRS
                                                , passwordIcSRS)
                                        + search + "&schem=0&op=ds&nstart=0&ncount=1000"));

                /* Create default column with type of boolean. 
                 * The checkboxes in the GridView are bound to this 
                 * column, which will be hidden by "Import.aspx.cs".
                 */
                devices.Columns.Add("Selected", typeof(bool));

                // Create default column which shows the current item index.
                devices.Columns.Add("#");

                // Parse Xml Nodes
                foreach (XmlNode node in doc.DocumentElement.ChildNodes)
                {
                    foreach (XmlNode current in node.ChildNodes)
                    {
                        /* Check if the name of the current node is not already contained in 
                         * DataTable.Columns and if current nodes name not equals "final_CountId"
                         * which should not be displayed in the search result grid view.
                         */
                        if (!devices.Columns.Contains(current.Name) && !current.Name.Equals("final_CountId"))
                        {
                            devices.Columns.Add(current.Name);
                        }
                    }
                }

                // Fill current DataTable with attributes
                fillTableData(doc, devices);
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Error!\n " + ex.ToString());
            }
            return devices;
        }

        private DataTable getSources()
        {
            // Create DataTable which has to be returned.
            DataTable sources = new DataTable();
            try
            {
                // Load XML-Document from icsrs.iaea.org, using the getXmlStream Method.
                XmlDocument doc = new XmlDocument();
                //doc.Load(getXmlStream("https://icsrs.iaea.org/rais_search.aspx?username=rais_user&pwd=X9zb2[8&qry=" + search + "&nstart=1&ncount=1000&schem=0&op=s"));
                                doc.Load(getXmlStream(
                                        string.Format("https://icsrs.iaea.org/rais_search.aspx?username={0}&pwd={1}&qry="
                                                , loginIcSRS
                                                , passwordIcSRS)
                                        + search + "&nstart=1&ncount=1000&schem=0&op=s"));

                /* Create default column with type of boolean. 
                 * The checkboxes in the GridView are bound to this 
                 * column, which will be hidden by "Import.aspx.cs".
                 */
                sources.Columns.Add("Selected", typeof(bool));

                // Create default column which shows the current item index.
                sources.Columns.Add("#");

                // Parse Xml Nodes
                foreach (XmlNode node in doc.DocumentElement.ChildNodes)
                {
                    foreach (XmlNode current in node.ChildNodes)
                    {
                        /* Check if the name of the current node is not already contained in 
                        * DataTable.Columns and if current nodes name not equals "final_CountId"
                        * which should not be displayed in the search result grid view.
                        */
                        if (!sources.Columns.Contains(current.Name) && !current.Name.Equals("final_CountId"))
                        {
                            sources.Columns.Add(current.Name);
                        }
                    }
                }

                // Fill current DataTable with attributes
                fillTableData(doc, sources);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
            }
            return sources;
        }

        private DataTable getManufacturer()
        {
            // Create DataTable which has to be returned.
            DataTable manufacturer = new DataTable();
            try
            {
                // Load XML-Document from icsrs.iaea.org, using the getXmlStream Method.
                XmlDocument doc = new XmlDocument();
                //doc.Load(getXmlStream("https://icsrs.iaea.org/rais_search.aspx?username=rais_user&pwd=X9zb2[8&qry=" + search + "&nstart=1&ncount=1000&schem=0&op=ss"));
                                doc.Load(getXmlStream(
                                        string.Format("https://icsrs.iaea.org/rais_search.aspx?username={0}&pwd={1}&qry="
                                                , loginIcSRS
                                                , passwordIcSRS)
                                        + search + "&nstart=1&ncount=1000&schem=0&op=ss"));

                /* Create default column with type of boolean. 
                 * The checkboxes in the GridView are bound to this 
                 * column, which will be hidden by "Import.aspx.cs".
                 */
                manufacturer.Columns.Add("Selected", typeof(bool));

                // Create default column which shows the current item index.
                manufacturer.Columns.Add("#");

                // Parse Xml Nodes
                foreach (XmlNode node in doc.DocumentElement.ChildNodes)
                {
                    foreach (XmlNode current in node.ChildNodes)
                    {
                        /* Check if the name of the current node is not already contained in 
                         * DataTable.Columns and if current nodes name equals one of names below.
                        */
                        if (!manufacturer.Columns.Contains(current.Name))
                        {
                            if (current.Name.Equals("Company") || current.Name.Equals("Address1") || current.Name.Equals("Telephone1") || current.Name.Equals("Fax") || current.Name.Equals("E-Mail") || current.Name.Equals("Country"))
                                manufacturer.Columns.Add(current.Name);
                        }
                    }
                }

                // Fill current DataTable with attributes
                fillTableData(doc, manufacturer);
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
            }
            return manufacturer;
        }

        private Stream getXmlStream(string url)
        {
            // Creates a new HttpWebRequest and sets it's properties.
            webRequest = (HttpWebRequest)WebRequest.Create(url);
            webRequest.KeepAlive = false;
            webRequest.Method = "GET";

            // Create new HttpWebResponse and download the Response Stream.
            webResponse = (HttpWebResponse)webRequest.GetResponse();
            return webResponse.GetResponseStream();
        }

        private void fillTableData(XmlDocument doc, DataTable dt)
        {
            // Parse Xml Nodes for inserting the returned values into the DataTable
            foreach (XmlNode node in doc.DocumentElement.ChildNodes)
            {
                // Create new DataRow
                DataRow row = dt.NewRow();

                // Set default values for Columns: "Selected" (row checked), and "#" (index of current row)
                row[0] = false;
                row[1] = dt.Rows.Count + 1;

                // Set values for the current row
                foreach (XmlNode current in node.ChildNodes)
                {
                    if (row.Table.Columns.Contains(current.Name))
                        row[current.Name] = current.InnerText;
                }

                // Add DataRow to the DataTable
                dt.Rows.Add(row);
            }
        }

        #endregion
    }
}